-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `DataFieldsOrigArchive`
--

CREATE TABLE IF NOT EXISTS `DataFieldsOrigArchive` (
  `FieldName` text NOT NULL,
  `FieldDescrip` text NOT NULL,
  `FieldType` text NOT NULL,
  `FieldWidth` text NOT NULL,
  `FieldDecimal` text NOT NULL,
  `FieldMinValue` text NOT NULL,
  `FieldMaxValue` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DataFieldsOrigArchive`
--

INSERT INTO `DataFieldsOrigArchive` (`FieldName`, `FieldDescrip`, `FieldType`, `FieldWidth`, `FieldDecimal`, `FieldMinValue`, `FieldMaxValue`) VALUES
('ACTIVITY', 'Stock, sample, harvest', 'C', '5', '0', '', ''),
('AIRPRES', 'Air pressure, millibars', 'N', '8', '2', '', ''),
('AIRTEMP', 'Air temperature, degrees C.', 'N', '4', '1', '', ''),
('ALKA', 'Alkalinity, CACO3 mg/L', 'N', '5', '0', '', ''),
('ALKABOT', 'Alkalinity at bottom, CACO3 mg/L', 'N', '5', '0', '', ''),
('ALKAMID', 'Alkalinity at mid, CACO3 mg/L', 'N', '5', '0', '', ''),
('ALKATOP', 'Alkalinity at top, CACO3 mg/L', 'N', '5', '0', '', ''),
('ANEURAE', 'na', 'N', '6', '0', '', ''),
('ANGULAR', 'na', 'N', '6', '0', '', ''),
('AREA', 'Area of pond at a depth, m2', 'N', '8', '2', '', ''),
('ASH', 'Ash', 'N', '8', '2', '', ''),
('ASPLAN', 'na', 'N', '6', '0', '', ''),
('ATEMPMAX', 'Maximum air temperature, degrees C.', 'N', '4', '1', '', ''),
('ATEMPMIN', 'Minimum air temperature, degrees C.', 'N', '4', '1', '', ''),
('AVG_SIZE', 'Weight of dead fish, g.', 'N', '6', '1', '', ''),
('B', 'Boron', 'N', '4', '1', '', ''),
('BG', 'Phytoplankton: blue-green, #', 'N', '6', '0', '', ''),
('BIDENTAT', 'na', 'N', '6', '0', '', ''),
('CA', 'Calcium,', 'N', '6', '1', '', ''),
('CAGE', 'Cage number', 'C', '5', '0', '', ''),
('CALYCIF', 'na', 'N', '6', '0', '', ''),
('CAUDATUS', 'na', 'N', '6', '0', '', ''),
('CHACORR', 'Chlorophyll-a(corrected), mg/m3', 'N', '4', '0', '', ''),
('CHAUNC', 'Chlorophyll-a(uncorrected), mg/m3', 'N', '4', '0', '', ''),
('CHBUNC', 'Chlorophyll-b(uncorrected), mg/m3', 'N', '4', '0', '', ''),
('CHCUNC', 'Chlorophyll-c(uncorrected), mg/m3', 'N', '4', '0', '', ''),
('CHLOROA', 'Chlorophyll-a(corrected), mg/m3', 'N', '4', '0', '', ''),
('CHLOROB', 'Chlorophyll-b(corrected), mg/m3', 'N', '4', '0', '', ''),
('CHLOROC', 'Chlorophyll-c(corrected), mg/m3', 'N', '4', '0', '', ''),
('CL', 'Chlorine', 'N', '7', '1', '', ''),
('CLACOR', 'Chlorophyll-a(corrected), mg/m3', 'N', '4', '0', '', ''),
('CLADOCER', 'Zooplankton: cladocera, #/m3', 'N', '6', '0', '', ''),
('CLAY', 'Clay, percent', 'N', '5', '1', '100', '0'),
('CLOUDS', 'Clouds', 'N', '4', '0', '', ''),
('CO3', 'Carbonate', 'N', '4', '1', '', ''),
('COMPOST', 'na', 'C', '5', '0', '', ''),
('CONDUCT', 'na', 'N', '10', '0', '', ''),
('COPEPODA', 'Zooplankton: copepoda, #/m3', 'N', '6', '0', '', ''),
('COXD', 'Chemical oxygen demand, mg/L', 'N', '6', '1', '', ''),
('CU', 'Copper, mg/L', 'N', '4', '1', '', ''),
('DATE', 'Observation date, DD/MM/YY', 'D', '8', '0', '', ''),
('DEADNO', 'Number of dead', 'N', '6', '0', '', ''),
('DEADWT', 'Weight of dead', 'N', '10', '2', '', ''),
('DECAPODA', 'Benthos: decapoda, #/m2', 'N', '6', '0', '', ''),
('DEPTH', 'Depth of observation', 'N', '4', '2', '', ''),
('DIAPH', 'na', 'N', '6', '0', '', ''),
('DIATOM', 'Phytoplankton: diatom, #', 'N', '6', '0', '', ''),
('DKBOTRES', 'Dark bottle respiration, mg-O/L/d', 'N', '5', '1', '', ''),
('DO', 'Dissolved oxygen at depth, mg/L', 'N', '4', '1', '', ''),
('DOBOT', 'Dissolved oxygen at top, mg/L', 'N', '4', '1', '', ''),
('DOMID', 'Dissolved oxygen at middle, mg/L', 'N', '4', '1', '', ''),
('DOTOP', 'Dissolved oxygen at top, mg/L', 'N', '4', '1', '', ''),
('DOZERO', 'Dissolved oxygen at zero???', 'N', '4', '1', '', ''),
('ENCENTR', 'na', 'N', '6', '0', '', ''),
('EVAP', 'Evaporation, mm/day', 'N', '4', '1', '', ''),
('EXCHAL', 'Exchanged Aluminum, mg/kg', 'N', '5', '1', '', ''),
('EXCHH', 'Exchanged Hydrogen, meq/100g', 'N', '5', '1', '', ''),
('EXCHNA', 'Exchanged Sodium, meq/100g', 'N', '5', '1', '', ''),
('EXPNO', 'Experiment number', 'C', '2', '0', '', ''),
('EXTRA', 'Extra ?, Yes or No', 'C', '1', '0', '', ''),
('FALCATUS', 'na', 'N', '6', '0', '', ''),
('FE', 'Iron', 'N', '4', '1', '', ''),
('FILINIA', 'na', 'N', '6', '0', '', ''),
('GREEN', 'Phytoplankton: green, #', 'N', '6', '0', '', ''),
('GROSPROD', 'Gross production, carbon mg/m3/d', 'N', '10', '2', '', ''),
('H2OFLOW', 'Water flow, cubic meters', 'N', '4', '0', '', ''),
('HARDNESS', 'Hardness, CaCO3 mg/L', 'N', '5', '1', '', ''),
('HAVANAEN', 'na', 'N', '6', '0', '', ''),
('HCO3', 'na', 'N', '4', '1', '', ''),
('HEXARTH', 'na', 'N', '6', '0', '', ''),
('HUMIDITY', 'Humidity', 'N', '5', '1', '', ''),
('HUMIDMN', 'Humidity, minimum', 'N', '5', '1', '', ''),
('HUMIDMX', 'Humidity, maximum', 'N', '5', '1', '', ''),
('INFLOW', 'Inflow ?, Yes or No', 'C', '1', '0', '', ''),
('INPQTY', 'Quantity of nutrient input, kg/ha', 'N', '8', '2', '', ''),
('INSECTA', 'Benthos: insecta, #/m2', 'N', '6', '0', '', ''),
('K', 'Potassium,', 'N', '7', '1', '', ''),
('KERATTEL', 'na', 'N', '6', '0', '', ''),
('KJN', 'Kjeldahl Nitrogen, mg/L', 'N', '6', '2', '', ''),
('LECANE', 'na', 'N', '6', '0', '', ''),
('LIMENEUT', 'Lime neutralizer, percent', 'N', '5', '1', '100', '0'),
('LIMEREQ', 'Lime required, kg/ha', 'N', '6', '1', '', ''),
('MACROTHX', 'na', 'N', '6', '0', '', ''),
('MAXTMPB', 'Pond temperature, degrees C.', 'N', '4', '1', '', ''),
('MAXTMPT', 'Pond temperature, degrees C.', 'N', '4', '1', '', ''),
('MG', 'Magnesium, meq/100g', 'N', '7', '1', '', ''),
('MINTMPB', 'Pond temperature, degrees C.', 'N', '4', '1', '', ''),
('MINTMPT', 'Pond temperature, degrees C.', 'N', '4', '1', '', ''),
('MIX', 'na', 'C', '10', '0', '', ''),
('MOINA', 'na', 'N', '6', '0', '', ''),
('MOLLUSCA', 'Benthos: mollusca, #/m2', 'N', '6', '0', '', ''),
('N', 'na', 'N', '4', '1', '', ''),
('NA', 'na', 'N', '7', '1', '', ''),
('NAUPLIUS', 'na', 'N', '6', '0', '', ''),
('NETPROD', 'Net production, carbon mg/m3/d', 'N', '10', '2', '', ''),
('NH3B', 'Ammonia at bottom, mg/L', 'N', '4', '2', '', ''),
('NH3M', 'Ammonia at middle, mg/L', 'N', '4', '2', '', ''),
('NH3N', 'Ammonia nitrogen, mg/L', 'N', '7', '2', '', ''),
('NH3T', 'Ammonia at top, mg/L', 'N', '4', '2', '', ''),
('NILSONI', 'na', 'N', '6', '0', '', ''),
('NO2_3N', 'Nitrogen nitrite and nitrate', 'N', '6', '2', '', ''),
('NO2N', 'Nitrogen nitrite', 'N', '6', '2', '', ''),
('NO3N', 'Nitrogen nitrate', 'N', '7', '2', '', ''),
('NUTASH', 'Nutrient ash, percent', 'N', '5', '1', '100', '0'),
('NUTCA', 'Calcium content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTDRY', 'Nutrient dry content, percent', 'N', '5', '1', '100', '0'),
('NUTK', 'Potassium content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTMG', 'Magnesium content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTMIX', 'Compost mix, %', 'N', '5', '1', '100', '0'),
('NUTMOIST', 'Nutrient moisture, percent', 'N', '5', '1', '100', '0'),
('NUTN', 'Nitrogen content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTNA', 'Sodium content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTNO3', 'Nitrate content, % dry matter', 'N', '5', '1', '', ''),
('NUTORGC', 'Org. Carbon content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTP', 'Phosphorus content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTS', 'Sulphur content, % dry matter', 'N', '5', '1', '100', '0'),
('NUTTYPE', 'Type of nutrient input', 'C', '7', '', '', ''),
('OBENTHO', 'Benthos: other, #/m2', 'N', '6', '0', '', ''),
('OBSERVE', 'Observation', 'M', '10', '0', '', ''),
('OPHYTO', 'Phytoplankton: other, #', 'N', '6', '0', '', ''),
('ORGC', 'Organic carbon', 'N', '5', '1', '', ''),
('ORGMATT', 'Organic matter, percent', 'N', '5', '1', '100', '0'),
('ORTHOP', 'Orthophosphate, phosphorous mg/L', 'N', '5', '2', '', ''),
('OSTRACOD', 'na', 'N', '6', '0', '', ''),
('OTHORGQ', 'Other organic input quantity', 'N', '3', '0', '', ''),
('OTHORTYP', 'Other organic input type', 'C', '7', '0', '', ''),
('OVERFLOW', 'Overflow ?, Yes or No', 'C', '1', '0', '', ''),
('OZOO', 'Zooplankton: other, #/m2', 'N', '6', '0', '', ''),
('P', 'Phosphorus, mg/L', 'N', '4', '2', '', ''),
('PH', 'pH', 'N', '4', '1', '14', '0'),
('PHBOT', 'pH at bottom', 'N', '4', '1', '14', '0'),
('PHCOL', 'pH column sample', 'N', '4', '1', '14', '0'),
('PHDRY', 'pH (dry)', 'N', '4', '1', '14', '0'),
('PHMID', 'pH at middle', 'N', '4', '1', '14', '0'),
('PHTOP', 'pH at top', 'N', '4', '1', '14', '0'),
('PHWET', 'pH (wet)', 'N', '4', '1', '14', '0'),
('PILE', 'Pile', 'C', '10', '0', '', ''),
('POLYARTH', 'na', 'N', '6', '0', '', ''),
('POND', 'Pond code', 'C', '5', '0', '', ''),
('PONDRESP', 'Pond respiration, oxygen mg/L/d', 'N', '8', '2', '', ''),
('POPNO', 'Population number', 'N', '6', '0', '', ''),
('POPWT', 'Population weight, kg', 'N', '6', '1', '', ''),
('PROTOZOA', 'na', 'N', '6', '0', '', ''),
('QUADRI', 'na', 'N', '6', '0', '', ''),
('RAIN', 'Rainfall, cm/day', 'N', '5', '1', '', ''),
('RAINCUM', 'Cumulative rainfall, cm', 'N', '5', '0', '', ''),
('RAINDUR', 'Rain duration, minutes', 'N', '4', '0', '', ''),
('REPLICATE', 'Treatment replication number', 'N', '2', '0', '', ''),
('REPRONO', 'Reproduction number', 'N', '6', '0', '', ''),
('REPROWT', 'Reproduction weight, kg', 'N', '8', '2', '', ''),
('ROTIFERA', 'Zooplankton: rotifera, #/m3', 'N', '7', '1', '', ''),
('ROUNDWRM', 'na', 'N', '6', '0', '', ''),
('SALT', 'Salinity, ppt', 'N', '6', '2', '', ''),
('SALTQTY', 'Salinity, ppt', 'N', '6', '2', '', ''),
('SAMLT', 'Sample length, cm', 'N', '5', '1', '', ''),
('SAMLTNO', 'Sample length number', 'N', '4', '0', '', ''),
('SAMLTSD', 'Sample length standard deviation, cm', 'N', '6', '2', '', ''),
('SAMWT', 'Sample weight, g', 'N', '5', '1', '', ''),
('SAMWTF', 'Sample weight, g  Females', 'N', '5', '1', '', ''),
('SAMWTFNO', 'Sample weight number  Females', 'N', '4', '0', '', ''),
('SAMWTFSD', 'Sample weight standard deviation, cm  Females', 'N', '6', '2', '0', ''),
('SAMWTM', 'Sample weight, g  Males', 'N', '5', '1', '', ''),
('SAMWTMNO', 'Sample weight number  Males', 'N', '3', '0', '', ''),
('SAMWTMSD', 'Sample weight standard deviation, g  Males', 'N', '6', '2', '', ''),
('SAMWTNO', 'Sample weight number', 'N', '3', '0', '', ''),
('SAMWTSD', 'Sample weight standard deviation, g', 'N', '6', '2', '', ''),
('SAND', 'Sand, percent', 'N', '5', '1', '100', '0'),
('SCACO3', 'Soil free CaCO3, meq/L', 'N', '5', '1', '', ''),
('SDISKA', 'Secchi disk visibility depth A, cm', 'N', '4', '1', '', ''),
('SDISKB', 'Secchi disk visibility depth B, cm', 'N', '4', '1', '', ''),
('SEEPAGE', 'Seepage, cm/day', 'N', '5', '1', '', ''),
('SILT', 'Silt, percent', 'N', '5', '1', '100', '0'),
('SITE', 'Site code', 'C', '1', '0', '', ''),
('SO4', 'Sulfate', 'N', '6', '1', '', ''),
('SOILAL', 'Soil aluminum, ppm', 'N', '6', '0', '', ''),
('SOILCA', 'Soil calcium, meq/100g', 'N', '6', '1', '', ''),
('SOILCEC', 'Soil CEC, meq/100g', 'N', '5', '1', '', ''),
('SOILCL', 'Soil chlorine, ppm', 'N', '5', '1', '', ''),
('SOILCU', 'Soil copper, ppm', 'N', '6', '0', '', ''),
('SOILFE', 'Soil iron, ppm', 'N', '6', '0', '', ''),
('SOILK', 'Soil potassium, ppm', 'N', '6', '0', '', ''),
('SOILMG', 'Soil magnesium, meq/100g', 'N', '6', '1', '', ''),
('SOILMN', 'Soil manganese, ppm', 'N', '6', '0', '', ''),
('SOILN', 'Soil nitrogen, ppm', 'N', '6', '2', '', ''),
('SOILNA', 'Soil sodium, meq/100g', 'N', '6', '1', '', ''),
('SOILNH4', 'Soil NH4-N, ppm', 'N', '7', '1', '', ''),
('SOILNO3', 'Soil NO3-N, ppm', 'N', '7', '1', '', ''),
('SOILP', 'Soil phosphorus, ppm', 'N', '6', '0', '', ''),
('SOILPY', 'Soil py, ppm', 'N', '6', '0', '', ''),
('SOILSALT', 'Soil soluble salt, mmhos/cm', 'N', '4', '1', '', ''),
('SOILSO4', 'Soil SO4-S, ppm', 'N', '6', '0', '', ''),
('SOILZN', 'Soil zinc, ppm', 'N', '6', '1', '', ''),
('SOL_QTY', 'Solar radiation', 'N', '8', '2', '', ''),
('SOLAR_C', 'Solar radiation, cal/cm2/day', 'N', '10', '2', '', ''),
('SOLAR_E', 'Solar radiation, E/m2/day', 'N', '10', '2', '', ''),
('SOLAR_K', 'Solar radiation, kW/m2/h', 'N', '10', '2', '', ''),
('SOLAR_L', 'Solar radiation, lux * 1000', 'N', '10', '2', '', ''),
('SOLARCUM', 'Cumulative solar radiation, units/d', 'N', '10', '2', '', ''),
('SOLCODE', 'Solar unit code', 'C', '1', '', '', ''),
('SOLUNIT', 'Solar radiation unit', 'C', '10', '0', '', ''),
('SPECIES', 'Species code', 'C', '5', '0', '', ''),
('STKWT', 'Weight of stock, g', 'N', '6', '1', '', ''),
('STKWTNO', 'Number stocked', 'N', '5', '0', '', ''),
('SUN', 'Sunshine, min./d', 'N', '6', '0', '', ''),
('SURVIVAL', 'na', 'N', '6', '0', '', ''),
('TEMPZERO', 'na', 'N', '4', '1', '', ''),
('THRMOCYC', 'na', 'N', '6', '0', '', ''),
('TIME', 'Time of day, 24-hour format', 'C', '4', '0', '2400', '0'),
('TOTALN', 'Total nitrogen, mg/L', 'N', '6', '2', '', ''),
('TOTALP', 'Total phosphorus, mg/L', 'N', '6', '2', '', ''),
('TRICHO', 'na', 'N', '6', '0', '', ''),
('TROCHOS', 'na', 'N', '6', '0', '', ''),
('TRT_CODE', 'Treatment code', 'C', '6', '0', '', ''),
('TRT_DESC', 'Treatment description', 'C', '80', '0', '', ''),
('TSS', 'Total suspended solids, mg/L', 'N', '4', '0', '', ''),
('TVS', 'Total volatile solids, mg/L', 'N', '4', '0', '', ''),
('VAPORMN', 'Vapor, minimum', 'N', '5', '1', '', ''),
('VAPORMX', 'Vapor, maximum', 'N', '5', '1', '', ''),
('VOLUME', 'Volume at a depth, m3', 'N', '10', '1', '', ''),
('WATERSHE', 'Watershed area, m2', 'N', '10', '1', '', ''),
('WHOLPROD', 'na', 'N', '10', '0', '', ''),
('WIND', 'Wind speed, km/hr', 'N', '5', '1', '', ''),
('WINDCUM', 'Cumulative wind, km/hr', 'N', '3', '0', '', ''),
('WINDDIR', 'Wind direction', 'C', '5', '0', '', ''),
('WORKPLAN', 'Workplan or cycle number', 'C', '2', '0', '', ''),
('WTEMPB', 'Water temperature at bottom, degrees C.', 'N', '4', '1', '', ''),
('WTEMPBMN', 'Min. water temperature, bottom, degrees C', 'N', '4', '1', '', ''),
('WTEMPBMX', 'Max. water temperature, bottom, degrees C.', 'N', '4', '1', '', ''),
('WTEMPM', 'Water temperature, middle, degrees C.', 'N', '4', '1', '', ''),
('WTEMPT', 'Water temperature, top, degrees C.', 'N', '4', '1', '', ''),
('WTEMPTMN', 'Min. water temperature, top, degrees C.', 'N', '4', '1', '', ''),
('WTEMPTMX', 'Max. water temperature, top, degrees C.', 'N', '4', '1', '', ''),
('ZN', 'Zinc, mg/L', 'N', '4', '1', '', '');
